Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Migrating an OpenEdge database to MS SQL Server

The DataServer for MS SQL Server supports the Progress-to-MSS utility that allows you to migrate an OpenEdge database. While the DataServer makes a data source conform to an OpenEdge database, this utility provides compatibility in the opposite direction. It copies an existing OpenEdge database schema into a target data source.

The Progress-to-MSS utility performs the following tasks:

Creates objects in the target data source.
Creates the schema holder and schema image.
Optionally populates the data source by dumping and loading the data from the OpenEdge database.

The MS SQL Server data source that you create with this utility is a basis for an application database. Before deploying your new data source, you might want to make manual adjustments to take advantage of additional MS SQL Server features that are not supported by the migration utility.

The Progress-to-MSS utility requires a local OpenEdge database.